
GO
CREATE TABLE [dbo].[AboutUs](
	[AboutUsID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[NameFull] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Description] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Createdate] [datetime] NULL,
 CONSTRAINT [PK_AboutUs] PRIMARY KEY CLUSTERED 
(
	[AboutUsID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Account](
	[UserName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[PassWord] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Name] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Page] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Role] [bit] NULL,
	[Active] [bit] NULL,
 CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED 
(
	[UserName] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Contacts](
	[ContactID] [nvarchar](36) COLLATE Vietnamese_CI_AS NOT NULL,
	[Name] [nvarchar](200) COLLATE Vietnamese_CI_AS NULL,
	[Address] [nvarchar](200) COLLATE Vietnamese_CI_AS NULL,
	[Email] [nvarchar](50) COLLATE Vietnamese_CI_AS NULL,
	[Phone] [nvarchar](200) COLLATE Vietnamese_CI_AS NULL,
	[Position] [int] NULL,
 CONSTRAINT [PK_Contacts] PRIMARY KEY CLUSTERED 
(
	[ContactID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[News](
	[NewsID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[ImageUrl] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[NameFull] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[NameSort] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AbsDescription] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Description] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Createdate] [datetime] NULL,
 CONSTRAINT [PK_News] PRIMARY KEY CLUSTERED 
(
	[NewsID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Payments](
	[PaymentsID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[NameFull] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Account] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Description] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[IsBank] [bigint] NULL,
	[Position] [int] NULL,
	[Createdate] [datetime] NULL,
 CONSTRAINT [PK_Payments] PRIMARY KEY CLUSTERED 
(
	[PaymentsID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Services](
	[ServicesID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[NameFull] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Description] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Createdate] [datetime] NULL,
 CONSTRAINT [PK_Services] PRIMARY KEY CLUSTERED 
(
	[ServicesID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ShoppingCart](
	[ShoppingCartID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[OrderNumber] [float] NULL,
	[FullName] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Address] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Phone] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Content] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ProductsID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Createdate] [datetime] NULL,
 CONSTRAINT [PK_ShoppingCart] PRIMARY KEY CLUSTERED 
(
	[ShoppingCartID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[TypeProducts](
	[TypeProductsID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[NameFull] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[NameSort] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Postion] [int] NULL,
	[Createdate] [datetime] NULL,
 CONSTRAINT [PK_TypeProducts] PRIMARY KEY CLUSTERED 
(
	[TypeProductsID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Products](
	[ProductsID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[NameFull] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ProductsCode] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[PriceOld] [float] NULL,
	[Pricenew] [float] NULL,
	[thumbnail] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[preview] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Isnew] [bit] NULL,
	[Description] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[TypeProductsID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Createdate] [datetime] NULL,
 CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED 
(
	[ProductsID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Photos](
	[PhotosID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[thumbnail] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[preview] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ProductsID] [nvarchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Createdate] [datetime] NULL,
 CONSTRAINT [PK_Photos] PRIMARY KEY CLUSTERED 
(
	[PhotosID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]